if EXISTS 
 (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGoods]') and xtype='V')
     Drop view [dbo].[vw_EShopGoods]
